OpenEdge Data Management:<br />SQL Reference SQLIStatement.execute

Release 10.1A: OpenEdge Data Management:
SQL Reference

SQLIStatement.execute

Executes the SQL statement. This method is common to the SQLIStatement and SQLPStatement classes.

Format

public void execute()

Returns

None

Parameters

None

Throws

DhSQLException
Example

This code fragment illustrates the setParam and execute methods:
CREATE PROCEDURE insert_customer (
IN  cust_number INTEGER,
IN  cust_name   CHAR(20)
)
 
BEGIN
     SQLIStatement insert_cust = new SQLIStatement (
            "INSERT INTO customer VALUES (?,?) ");
     insert_cust.setParam (1, cust_number);
     insert_cust.setParam (2, cust_name);
     insert_cust.execute ();
END 